using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace QLKS.HeThongDAO
{
    public class Baocao
    {
        public static DataTable SelectAllDSPhong()
        {
            string sql = "SELECT MaPhong FROM Phong";
            return Config.AccessHelper.ExecuteQuery(sql);
        }

        public static DataTable doanhthu(string maphong,string dk1,string dk2,string dk3)
        {
            string sql = "SELECT ThanhTien FROM CTThuePhong,HoaDon where CTThuePhong.MaPhong = '"+maphong+"' And CTThuePhong.MaHoaDon = HoaDon.MaHoaDon "+dk1+" "+dk2+" "+dk3+"";
            return Config.AccessHelper.ExecuteQuery(sql);
        }
    }
}
